package com.seqb.manage.loupan.domain;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableLogic;
import com.baomidou.mybatisplus.annotation.TableName;
import com.seqb.common.dto.CommDTO;
import com.xuxueli.poi.excel.annotation.ExcelField;
import com.xuxueli.poi.excel.annotation.ExcelSheet;
import lombok.Data;
import org.apache.poi.hssf.util.HSSFColor;

import java.io.Serializable;
import java.util.Date;

/**
 * @author lilinshen
 * @title 楼盘信息表
 * @description 请填写相关描述
 * @date 2020-01-18
 */
@Data
@TableName("t_loupan")
@ExcelSheet(name = "楼盘信息", headColor = HSSFColor.HSSFColorPredefined.LIGHT_GREEN)
public class LoupanDO extends CommDTO implements Serializable {
    private static final long serialVersionUID = 1L;

    //唯一编号
    private Long id;
    //城市
    @ExcelField(name = "城市", width = 80)
    private String city;
    //镇区
    @ExcelField(name = "镇区", width = 80)
    private String district;
    //楼盘名称
    @ExcelField(name = "楼盘名称", width = 200)
    private String name;
    //建筑面积
    @ExcelField(name = "建筑面积", width = 100)
    private String areaRange;
    //房型
    @ExcelField(name = "房型", width = 100)
    private String roomDesc;
    //均价
    @ExcelField(name = "均价(元)", width = 100)
    private double averagePrice;
    //平均单价
    @ExcelField(name = "平均单价(元)", width = 110)
    private double averagePriceUnit;
    //房屋类型
    @ExcelField(name = "房屋类型", width = 100)
    private String houseType;
    //房屋装饰
    @ExcelField(name = "房屋类型", width = 100)
    private String decoration;
    //销售状态
    @ExcelField(name = "销售状态", width = 100)
    private String saleStatus;
    //总价起
    @ExcelField(name = "总价起(万/套)", width = 120)
    private double totalPriceStart;
    //封面图片
    private String coverPic;
    //访问路径
    @ExcelField(name = "访问路径", width = 450)
    private String url;
    //标签
    @ExcelField(name = "标签", width = 450)
    private String tags;
    //地址
    @ExcelField(name = "地址", width = 400)
    private String address;
    //创建者编号
    @TableField(fill = FieldFill.INSERT)
    private Long createNumber;
    //创建时间
    @TableField(fill = FieldFill.INSERT)
    private Date createDate;
    //修改时间
    @TableField(fill = FieldFill.INSERT_UPDATE, update = "now()")
    private Date updateDate;
    //版本号
    @TableField(fill = FieldFill.INSERT_UPDATE, update = "%s+1")
    private Long version;
    //是否删除(0-否，1-是)
    @TableLogic
    @TableField(fill = FieldFill.INSERT)
    private String isDelete;
}
